home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / status.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  456 b   |  25 lines  |  [TEXT/ttxt]
  1. connect (con1,localhost,root,,);
  2. connect (con2,localhost,root,,);
  3.  
  4. flush status;
  5. show status like 'Table_lock%';
  6. connection con1;
  7. SET SQL_LOG_BIN=0;
  8. drop table if exists t1;
  9. create table t1(n int);
  10. insert into t1 values(1);
  11. connection con2;
  12. lock tables t1 read;
  13. unlock tables;
  14. lock tables t1 read;
  15. connection con1;
  16. --send
  17. update t1 set n = 3;
  18. connection con2;
  19. sleep 0.5;
  20. unlock tables;
  21. connection con1;
  22. reap;
  23. show status like 'Table_lock%';
  24. drop table t1;
  25.